Materialized Views in Action
نویسنده
چکیده
Materialized views are a powerful feature that has been part of the Oracle RDBMS since version 8.1. Based upon the snapshot replication feature, they have evolved considerably into a capable tool for significantly improving performance on queries at higher levels of hierarchical organization structures. When they are effectively implemented across an entire data warehouse, the total number of logical reads can be reduced by well over 90%. Although materialized views are considered to be a data warehouse feature, they can also be employed in other environments, including Operational Data Stores (ODS), data marts, and reporting tables in OLTP environments, where end-users will perform rollup queries on the schema.
منابع مشابه
Incremental Maintenance of Recursive Views with Applications to Tabled Logic Programming
Materialized views are used extensively in data warehousing for faster responses to user queries. These views have to be maintained in response to the changes in the base relations. In many cases, it is observed that the changes to the base relation have small effects on the materialized views. Thus instead of recomputing the materialized view from scratch, incremental computation of changes to...
متن کاملDynamic Construction and Administration of the Workload Graph for Materialized Views Selection
To offer the best performance to each application (e.g., decision support systems) administration and optimization of database management systems is needed. In order to reduce administration costs and to provide continuous adaptation to changing workload patterns, selfmanagement techniques have been in the focus of researchers and DBMS vendors for recent years. One important topic in this area ...
متن کاملOptimizing Queries with Materialized Views
While much work has addressed the problem of maintaining materialized views, the important question of optimizing queries in the presence of materialized views has not been resolved. In this paper, we analyze the optimization question and provide a comprehensive and efficient solution. Our solution has the desirable property that it is a simple generalization of the traditional query optimizati...
متن کاملFast Discovery of Sequential Patterns Using Materialized Data Mining Views
Most data mining techniques consist in discovery of frequently occurring patterns in large data sets. From a user’s point of view, data mining can be seen as advanced querying, where each data mining query specifies the source data set and the requested class of patterns. Unfortunately, current data mining systems consume minutes or hours to answer simple queries, which makes them unsuitable fo...
متن کاملDetecting Redundancy in Data Warehouse Evolution
A Data Warehouse (DW) can be abstractly seen as a set of materialized views de ned over a set of remote data sources. A DW is intended to satisfy a set of queries. The views materialized in a DW relate to each other in a complex manner, through common subexpressions, in order to guarantee high query performance and low view maintenance cost. DWs are time varying. As time passes new materialized...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2005